create external table jms_dwd.dwd_yl_oms_order_tb_exporder_hi
(
  ID                   bigint             comment '主键id'
  INPUT_TIME           date               comment '订单录入时间'
  MAIL_NO              string             comment '物流运单号'
  update_time          date                comment '更新时间'
)PARTITIONED BY (
   `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd--hh)')
) comment'线下订单表dwd'
stored as parquet
location '/dw/hive/jms_dwd.db/external/dwd_yl_oms_order_tb_exporder_hi'
tblproperties (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);
